package com.zj.fx.mapper.month;

import com.zj.fx.model.month.MonthSupplytaskDtl;
import com.zj.fx.model.month.MonthSupplytaskDtlExample;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 月度供电所填报任务填报明细 MonthSupplytaskDtlMapper
 *
 * @author SQL_自动生成
 * @email ${email}
 * @date 2023-06-09 17:15:40
 */
@Mapper
public interface MonthSupplytaskDtlMapper {

    long countByExample(MonthSupplytaskDtlExample example);

    int deleteByExample(MonthSupplytaskDtlExample example);

    int deleteByPrimaryKey(String id);

    int insert(MonthSupplytaskDtl record);

    int insertSelective(MonthSupplytaskDtl record);

    List<MonthSupplytaskDtl> selectByExample(MonthSupplytaskDtlExample example);

    MonthSupplytaskDtl selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") MonthSupplytaskDtl record, @Param("example") MonthSupplytaskDtlExample example);

    int updateByExample(@Param("record") MonthSupplytaskDtl record, @Param("example") MonthSupplytaskDtlExample example);

    int updateByPrimaryKeySelective(MonthSupplytaskDtl record);

    int updateByPrimaryKey(MonthSupplytaskDtl record);

    List<MonthSupplytaskDtl> findupGrade(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> findFullMark(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl>  findgrade5by4 (MonthSupplytaskDtl monthSupplytaskDtl1);

    MonthSupplytaskDtl findgrade4Score(MonthSupplytaskDtl monthSupplytaskDtl);

    MonthSupplytaskDtl findgrade5Score(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> list4audit(MonthSupplytaskDtl monthSupplytaskDtl);

    List<String> findDistinctNum4byDep(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> findDistinctDept(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> findDistinctDeptAll(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> getScoreGroupbyTabbyDep(MonthSupplytaskDtl monthSupplytaskDtl);

    String findFullMarkbyFktaskid(String fktaskid);

    List<MonthSupplytaskDtl> findFinishMark(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> list4subaudit(MonthSupplytaskDtl monthSupplytaskDtl);

    String findSelfScoreTotal(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> findSelfScoreGroupbyTab(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> list4SelfResult(MonthSupplytaskDtl monthSupplytaskDtl);

    List<MonthSupplytaskDtl> list4supplydeduction(String id);

    List<MonthSupplytaskDtl> checkAllFill(MonthSupplytaskDtl monthSupplytaskDtl);
}